UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOo7YSv7tO8ZcEWVb2pPjauyqoIHHFy/jZgv1a41eCI='
WHERE
key_id = '20700a5c9e3846b35dcc6cfcb7e73b66be3b38996f36c7d9e9960fab68efbe76'
AND (
token = 'mOo7YSv7tO8ZcEWVb2pPjauyqoIHHFy/jZgv1a41eCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)