UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GmfGL8BaPRnFs458XNBIFCWeKYaT8Vir84vv/YJY1D4='
WHERE
key_id = 'd72e1720d88a4599571b8b287a171e2b79bf194dfb169417aa6b1ac04da9df47'
AND (
token = 'GmfGL8BaPRnFs458XNBIFCWeKYaT8Vir84vv/YJY1D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)