UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DB7XkCYr8PQqf9+fd0Po23jM/3lFiAl7wXH0ZTQVMk='
WHERE
key_id = '0d9f14cfad5af8333e82902dd467caddf63e1ffb34fd881167b23f1bf73175ca'
AND (
token = '7DB7XkCYr8PQqf9+fd0Po23jM/3lFiAl7wXH0ZTQVMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)