UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zk6HOZQxjDUw+xkLqYen5d5L+9xfVdIWmHC2oZ1Hkz4='
WHERE
key_id = 'b8e5c514200b2c49e28bd26bb02668a86580a1831fbb55c3086619a494e69cb2'
AND (
token = 'zk6HOZQxjDUw+xkLqYen5d5L+9xfVdIWmHC2oZ1Hkz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)