UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnfZ3f6AkFwdZImykyduQIn4Z6I6Si2pDc5QFB+GDhw='
WHERE
key_id = 'e8bd616246b75363f06f75b5c7c251366ba2e415efe29d5df7e0416c1f13cd0a'
AND (
token = 'CnfZ3f6AkFwdZImykyduQIn4Z6I6Si2pDc5QFB+GDhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)