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