UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFEpvOAbKEF8JKOWeGu9i96jap91theyya1+9+kVbRI='
WHERE
key_id = 'a1d69ff687d4d85b0d1e9d2c31bda47c767a1c0f94f360e2e18ad05875673303'
AND (
token = 'hFEpvOAbKEF8JKOWeGu9i96jap91theyya1+9+kVbRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)