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