UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0szm+9cvhf9pUOa6SMcUvrFomSJSVDNXvboa6juSCEc='
WHERE
key_id = '3c971c2267e4197b1d0f0046d6015d134fd9c6b838a5299cf12747cbb6353df6'
AND (
token = '0szm+9cvhf9pUOa6SMcUvrFomSJSVDNXvboa6juSCEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)