UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MOtSKCORgOcsrxuvyAD8rCJ58t42htN9wAl70f5c4BY='
WHERE
key_id = '6bfac336492f38ab534cd26406c164d434d6bec040111b9a9e72c9159f31f493'
AND (
token = 'MOtSKCORgOcsrxuvyAD8rCJ58t42htN9wAl70f5c4BY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)