UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4ej8Dhs4DhhRhbOXeNnuls1junUcRPbYn620y16hUE='
WHERE
key_id = '4618892e3382d31c79d4282756d1d4b67361776567459a72229c71f9287e079e'
AND (
token = 'H4ej8Dhs4DhhRhbOXeNnuls1junUcRPbYn620y16hUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)