UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBMSdLFBXAAqoxeGsrU6beofr3swz+2vinuDc4E8wHc='
WHERE
key_id = '03e2a468a7e590002c59ac74d0cee6652f2b9e6929f924062e93ae9e0a09f86b'
AND (
token = 'KBMSdLFBXAAqoxeGsrU6beofr3swz+2vinuDc4E8wHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)