UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kN6ZMDq6Kiw8jDbDRnOnuNIztxlplYZPYAfX5gccf8U='
WHERE
key_id = '8b717e83812480dcb7cf1beccb25784ab31fe2f65c07ede106702478655aaa95'
AND (
token = 'kN6ZMDq6Kiw8jDbDRnOnuNIztxlplYZPYAfX5gccf8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)