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