UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i1mzT9OkX+gA6nPrTINuhkNo+dqvFckhPvViStE1gmw='
WHERE
key_id = 'c859d9141d4b706e625810d13552c4d8bba1f28743b0db4c2f1956a7bc8c8ff0'
AND (
token = 'i1mzT9OkX+gA6nPrTINuhkNo+dqvFckhPvViStE1gmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)