UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aLi0NTdcDoCrs/yX4MvcM47r/Bae+ehYBDK8ghVdRcU='
WHERE
key_id = '21482899dfcae3b2b6f887234537832320f7cd6ce199cbce4378eee994006aa7'
AND (
token = 'aLi0NTdcDoCrs/yX4MvcM47r/Bae+ehYBDK8ghVdRcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)