UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xK9IZZ7ZgLQUvxpRmtA7N5zn1/ojaU5jythDYhq1io='
WHERE
key_id = '7127ff37f550ec1cd9c6be074150185665e9209a80357519271d167ca7ee3995'
AND (
token = '6xK9IZZ7ZgLQUvxpRmtA7N5zn1/ojaU5jythDYhq1io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)