UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NZ1p5lu4Vh+RouJIF/58cMtwMQ+zd0MOHDtpYDy3Zo='
WHERE
key_id = 'b46d1fe1eaf02c4b1f00a9240360e66e2bb216a7176561add5c5366bea19e589'
AND (
token = '7NZ1p5lu4Vh+RouJIF/58cMtwMQ+zd0MOHDtpYDy3Zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)