UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQfT8jCjPchcBREnJ/Z9RSGYIIeHViDY1Tj/DztZ4yw='
WHERE
key_id = '110e917cd5531a51d5c216d46c158b48bcdb0a21d3cef8d3922f1bfdfc4afe30'
AND (
token = 'xQfT8jCjPchcBREnJ/Z9RSGYIIeHViDY1Tj/DztZ4yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)