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