UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Z/xJ5AXYqNtuGDZAVZOH1qS/NYTZUZ3KU3sVZhHdJ0='
WHERE
key_id = '23bcfc95a443905c67122baa80475ba9f442b98a39eb001a5f9c7fe875b27339'
AND (
token = '1Z/xJ5AXYqNtuGDZAVZOH1qS/NYTZUZ3KU3sVZhHdJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)