UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnNlThOcOfRECS/axp31LlzvCip7DXGzSFmzxCeVhzo='
WHERE
key_id = 'f05fc5d9405dd6027b7ec8ab8a8158b1249c16d4acb69c63e4b00a8bef4d66dd'
AND (
token = 'xnNlThOcOfRECS/axp31LlzvCip7DXGzSFmzxCeVhzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)