UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6sXueXI2az/YwEuuUGY7MrIt+88uCgJ+a1QPhiwUkPM='
WHERE
key_id = '4fe46ca847f9c04eee780131376f443663fce4fd9bfe3a11ef667502574f2748'
AND (
token = '6sXueXI2az/YwEuuUGY7MrIt+88uCgJ+a1QPhiwUkPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)