UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0rh6ihpjwcaYtHM9Rmwx7VuSrK6dT6y99ep667P0nEA='
WHERE
key_id = '81b149cc10ecfbac0910a7872811c9fec83afdccaa28ce69186ad8546347d946'
AND (
token = '0rh6ihpjwcaYtHM9Rmwx7VuSrK6dT6y99ep667P0nEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)