UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aNSx1+qY166WlIgfh4Zupi/1gi+s+vNLOnu0o3tmRSs='
WHERE
key_id = 'a912fa2e7e8f48475b9e6420328047fa2e320cc7115a363e6fd3d124935b4173'
AND (
token = 'aNSx1+qY166WlIgfh4Zupi/1gi+s+vNLOnu0o3tmRSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)