UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NpqxdYG+vxmW3e8lSAD/kHM9JkNvAm+OqdkVkYwTmw='
WHERE
key_id = '0a65388d10430b4cda86a988c6d533984bd58a92a90b1800b973166e9187e962'
AND (
token = '3NpqxdYG+vxmW3e8lSAD/kHM9JkNvAm+OqdkVkYwTmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)