UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tGLTlhQGic2p+AnT6kd84t8sjinj8HXyVOLp/6LNgDg='
WHERE
key_id = '5f572e78a7c31a7e55dc2d4bdd0dc70a1f3c798467c93a3986d33daaf87dced6'
AND (
token = 'tGLTlhQGic2p+AnT6kd84t8sjinj8HXyVOLp/6LNgDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)