UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TSWGhs51E+CWv+90EnpTHGi/ZeCBeElc/6iDJzXiQA='
WHERE
key_id = '8b5c41deae995e53c1f9be0865d62d7e3e88ccb0ba817de31558b86311ad8abf'
AND (
token = '6TSWGhs51E+CWv+90EnpTHGi/ZeCBeElc/6iDJzXiQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)