UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jT7qHe2AtF+ELp/FLx1h1WASCm23U696agTpOsR24E4='
WHERE
key_id = 'a2544861fe9ca7461b0e08fd0bf17335d1158071e5df73a893c850e691d9215a'
AND (
token = 'jT7qHe2AtF+ELp/FLx1h1WASCm23U696agTpOsR24E4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)