UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jBfcy1PYYrvtvk5WxLb20ORtv9mk1Ay7nnPvFFWuCko='
WHERE
key_id = 'cd9725aef50be390272cf475dadede8fcee0a28b1edcc7c2ef6eb710a15f6f94'
AND (
token = 'jBfcy1PYYrvtvk5WxLb20ORtv9mk1Ay7nnPvFFWuCko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)