UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/u/uG1QYr7lIuXXEYHcOm+Q3tMYZvwGMlSKtPb6UiUA='
WHERE
key_id = '7e36165d193aebec116e4e268ab849db713e39769bef79edc37b96d2f09a2a3d'
AND (
token = '/u/uG1QYr7lIuXXEYHcOm+Q3tMYZvwGMlSKtPb6UiUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)