UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZRLliCR6ePXE07q3ED83Yo8Eb7CsMHPPg6t029HSkh0='
WHERE
key_id = '21043b6afc9e26adc1804533d52640e493cd083e8b6fee24107a84c92e6b9b65'
AND (
token = 'ZRLliCR6ePXE07q3ED83Yo8Eb7CsMHPPg6t029HSkh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)