UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ljX/zvc4LlIdVth1e0S5GsvhblcOq/PujntvtQ05ow='
WHERE
key_id = '4e167236527aa587d1170dac1997ea3a90f79b6e5b0c6c5d458b68980628cf6f'
AND (
token = '8ljX/zvc4LlIdVth1e0S5GsvhblcOq/PujntvtQ05ow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)