UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LqTDacH8f4p8GmWLVxVNeAHVBE0ndDBk9IfuaVoqKOY='
WHERE
key_id = '585d0e3d325251c9c3ad41bf75c898e299ecd407a27db43245dd775f82c37d31'
AND (
token = 'LqTDacH8f4p8GmWLVxVNeAHVBE0ndDBk9IfuaVoqKOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)