UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWkhgohrIe/1p8rFaLM8Ezcn2iPi1el15aY/eH+WtXo='
WHERE
key_id = '5173d5cbcb3752e65a51611a4a10bd8cf83468c321c677d37c8732853c31f53a'
AND (
token = 'YWkhgohrIe/1p8rFaLM8Ezcn2iPi1el15aY/eH+WtXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)