UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DCSuL97RwYQN9xIKxI4tUN6NmUqmIvzMqgsfJeBeauo='
WHERE
key_id = '24bb25d385dd6e97a44ea88a6548670f030a575fd35e175256cb57f2f7ce1ebd'
AND (
token = 'DCSuL97RwYQN9xIKxI4tUN6NmUqmIvzMqgsfJeBeauo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)