UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1fHvs94w7t5As9uzg2cYIFh0ttadTVUAsiSiMcnzkE='
WHERE
key_id = 'b40838862b6802b9127d93512c0d2ab5b894b3cd8c4fd1477f9d937b38e55c63'
AND (
token = 'p1fHvs94w7t5As9uzg2cYIFh0ttadTVUAsiSiMcnzkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)