UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zKw0fpkTvFVCO53g7I+T2FiVbL9a3dTZ3iKggzXDVk='
WHERE
key_id = 'e02f4f35fc272090b7eaadf7dae52636a0fbb9a3c4f80bf4cb1fba74183c88ca'
AND (
token = '0zKw0fpkTvFVCO53g7I+T2FiVbL9a3dTZ3iKggzXDVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)