UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfOjad6XVDyLqBrlY9VOrpjzFv36+emQayS9o2nWMkg='
WHERE
key_id = 'f80884fb691f3fba9d55ca607a2f42a7bfcdd2813e7118c1c09b5377c8461c8a'
AND (
token = 'ZfOjad6XVDyLqBrlY9VOrpjzFv36+emQayS9o2nWMkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)