UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCgQy3qJw8p1xe7VrrtdbPeslZmOlPOKP3K4+PofABU='
WHERE
key_id = '0d6adf292be27d53fd859431798736eacbe0ab2d28b06b6da69f55ccbaecd586'
AND (
token = 'VCgQy3qJw8p1xe7VrrtdbPeslZmOlPOKP3K4+PofABU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)