UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'klqc39AyEDNOo8ojgbNMNuEY39bP1R28YMFfXS3dwp8='
WHERE
key_id = '21422f43d3d5a38524e1d517f4311a3b101ba3b15015c6445e8fb72df374b981'
AND (
token = 'klqc39AyEDNOo8ojgbNMNuEY39bP1R28YMFfXS3dwp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)