UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/merFZyVkWQisC7Qi2dxEnya5QHqd19b9EeBoKXSfTc='
WHERE
key_id = '24e42ab3c5d5e28e3ff0c4ae2c5fd5f73ca6f299c50c98fabeaf6291e2be46bf'
AND (
token = '/merFZyVkWQisC7Qi2dxEnya5QHqd19b9EeBoKXSfTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)